Analysing data

Table of Contents

1. Analysing data
2. Contents:
3. The database:
4. Data cleaning
5. Correcting the database
6. Analysis plan
7. Describing the sample
8. Averages
9. T-test:
10. Doing the T-test yourself
11. The results of the T-test
12. Redoing the T-test
13. In Summary

The results of the T-test

The formula should be =TTEST(I2:I18,I19:I31,2,2)

The p value will be 0.000416

This is highly significant. The chance that these two groups are not different is 4 in 10,000.

This means the pain management course significantly improves wellbeing compared to controls.

However, the t-test on Excel does not give us confidence intervals for our difference. A better test would be the on using the website in the book: http://home.clara.net/sisa/t-test.htm.

Re do the test using this website and see what the confidence intervals are?